01. Introduction

CRUD App making Heading

Introduction

Building out a CRUD application

So far, we've built up a lot of the conceptual foundation we'd need to understand how to do real-world web development across the stack. In these next series of lessons from now until the end of this course, we'll pivot to becoming very hands-on, building a fully functional application from start to end.

Following every screencast, an interactive workspace will be provided so you can follow along in coding the steps of building out this To-Do application. You'll be building out the same application from now until the end of this course across these next 3 lessons. Starter code is provided above every instance of your workspace, in case you make a mistake somewhere and want to start from a clean slate at any point.

These next 3 lessons represent the meat of this course, where you'll be gaining a lot of hands-on experience.

ND004 C01 L05 01 CRUD App Making

CRUD SQL Quiz

QUIZ QUESTION: :

For each CRUD operation, can you identify the corresponding SQL command?

ANSWER CHOICES:



CRUD operation

SQL command

UPDATE

SELECT

INSERT

DELETE

SOLUTION:

CRUD operation

SQL command

UPDATE

SELECT

INSERT

DELETE

CRUD SQLAlchemy Quiz

QUIZ QUESTION: :

For each CRUD operation, there's also a corresponding command in the SQLAlchemy ORM. Can you match them as well?

ANSWER CHOICES:



CRUD operation / SQL command

ORM command

db.session.delete(user1)

user1.foo = 'new value'

User.query.all()

db.session.add(user1)

SOLUTION:

CRUD operation / SQL command

ORM command

db.session.delete(user1)

user1.foo = 'new value'

User.query.all()

db.session.add(user1)

CRUD App making Recap

What we'll build

ND004 C01 L05 01.1 CRUD App Making

Takeaways

In summary, here are the skills we'll master over these next 3 lesson as we build out this application:

  • Traversing across all layers of our backend stack, from our backend server in Flask to our database in Postgres, by understanding mappings between user operations, to the ORM, to the SQL executed on a database.
  • Developing using the MVC Model-View-Controller pattern, for architecting out our application
  • Handling changes to our data schema over time
  • Modeling relationships between objects in our web application
  • Implementing Search

We'll cover these skills through a hands-on approach by building out our to-do application across these next 3, final lessons of this course!

Next Concept